in staging we are merging the data and remove the
inconsistants data that type of situation what u will done
and type of functions u can use


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  


Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  


how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,


To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  






Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


what is the function of 'F10' informatica ?

4 Answers   IBM,


Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,


what is index?how it can work in informatica

0 Answers  


In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,


What is data caches/ index caches?

0 Answers  


Categories