May I know at what time will we get D band in tcs if we are on the bench continuously?and Is there any impact for our job?

Yes D band impact your role. If you are on the bench for a long time then you may get this band but that depends on your current manager. But if you have some project and you did some good work then they should not give D band