TCS pannel video call technical round interview on informatica selected

hi bro, can you send me the details which is present in notepad++

Bro a notepad file lo project reg details unai kada avi meku ok aithe mail ki pampistara ref kosam mer ok ante mail pedta

Can we keep the video off during interview??

Thanks yr

Very nice interviewer😁

Wow so nice interviewer. None of my interviewers gave the answer 😢

Bro can you please upload that project document open in note editor? Thanks in advance

bhai yaha to panelist hi question puch rha aur ans bhi khud hi de rha..nice interview.

All the interviewers should be like him ...the way he encouraging with the candidates is very nice and it was moreover like a interaction other than a DEBATE. very nice

He is asking very general questions for 4.2 , but 2 years there asking tough questions, i don't understand why like this, also he didn't answer, how he is getting selected.

hi

Interviewer is so nice, he can lead a team very efficiently by coping the team, super 1st Interviewer

TCS took only one round (this one) or more rounds were taken??

After 4+ yrs of experience, 12LPA is being offered??

Though questions are good and helpful but I'm not sure whether this is correct to upload the actual interview video. In a way, it looks like a staged interview as no employee of TCS would go and upload it.

Hi, which company you joined after all these Informatica Interviews? And at which LPA you? Have you faced any location challenges?

can you explain the first question.I didnot understood

Questions asked:
1. In the sequence generator, there are 2 ports CURVAL and NEXTVAL. Which one is larger/has a higher value?
- Current Value is the larger value because the nextval. You can optimize performance by connecting only the NEXTVAL port in a mapping.

2. Union Transformation, does it perform a union or union all?
- It performs a union all. It’s an active transformation because Although we have duplicate records, it is still not an a passive. There is a change happening to the row number, which is why it is active. To get rid of duplicates, you can select distinct through sorter transformation.

3. You have an unconnected lookup, in which scenario will you use only unconnected and not possible to use connected?
- When you want to call a lookup based on a condition such as if dept=10, then call the lookup, otherwise call the third lookup.

4. What is the reason that sorted input will improve the performance of aggregator?
- When you sort the data based on deptno for example, and when informatica is reading the data in the cache and a new group is encountered, informatica does not know whether the last record is dept 1,2, or 3, so the cache size will increase and performance will decrease.

5. If you have 10 records in a table, select * from table where rownum < 5, select * from table where rownum = 5, select * from table where rownum > 5, what will be the output?
- Rownum < 5 will give you 4 records
- Rownum = 5 and Rownum > 4 will not work.

6. Is NULL treated as the highest or lowest value?
- NULLS have the highest value. You have the option to do NULLS first/last in order by clause.

7. What are the limitations of pushdown optimization?
- Variable port cannot be used. Normalization, parameter files, XML Transformation will not work with this. It doesn't work when loading from flat file to database. Source and target must be the same database

8. What are the restrictions of a mapplet?
- Normalizer and XML transformations cannot be used. Sequence generator must be reusable. You also cannot have a target in a mapplet, so update strategy cannot be used either.

After interview u submit documents?or before
Because tcs check gap n

May I know the candidate name and contact number please, I will take few tips from him regarding informatica interviews

In which company you placed

Thnqq bro

How to apply for the job? Is there any written exam for this?

Which batch you are and have you select for this interview

Hi someshwar can I have your number?

Hi bro.. Do we have job opportunities into Informatica.. From which institution u took the course.. If u don't mind Can u give ur phone number.. I have some doubts so that i can get clarification by talking to you bro..

interviewer was very nice person... he is giving both questions and answers

Please upload if any other videos and also update here where you are joining

Thank you bro for uploading this video,it is very useful for others

Yah really good thank you

Have you went with Fake experience or real experience?

so much disturbance in the call.

Bro Raj student ha meeru

Thank you bro chaala baaga use avuthundi . . .motivationga untundhi . . Plz keep on posting as many as u can . . It is very motivational . . Is am subscribed now

Thnx for the video.
When did u started applying bro for the interviews..
Nd when u received calls nd this interview.?

How much package they offered?

Awesome bro thnqqqq soo much