Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

in static and dynamic which one is better

2 3284

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 6866

what is dynamic cashe

Informatica,

3 4479

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

Cap Gemini, IBM,

10 13183

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

Cap Gemini, Wipro,

10 12319

how to improve performence by using sorted input in aggrigator t/r.

2 4183

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 3961

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

Cap Gemini,

2 6965

what is flat file override?

Cap Gemini, HP,

1 8689

what is mapping override?

Cap Gemini,

2 5879

what is session override?

Cap Gemini,

2 9341

what is parameter file?

Cap Gemini,

1 4179

what is mapping parameter?

Cap Gemini,

2 4622

what is session parameters?

Cap Gemini,

1 4781

1 lac of flat fles in source how to load target at a time?

Cap Gemini,

4 7750


Post New Informatica Questions






Un-Answered Questions { Informatica }

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

156


what are factless facts? And in which scenario will you use such kinds of fact tables.

862


In which transformation you cannot drag ports into it?

179


In informatics server which files are created during the session rums?

170


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1453






Explain about cumulative Sum or moving sum?

184


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

421


Explain the shared cache and re-cache?

162


What is native users?

178


Briefly describe lookup transformation?

155


What are the databases that informatica can connect to windows?

158


Plz can any one say me how to get the informatica certification materials and dumps

1138


What is a sequence generator transformation?

144


How can you validate all mappings in the repository simultaneously?

183


What is meant by incremental aggregation?

142