Explain sql transformation in script mode examples in informatica


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

Post New Answer

More Informatica Interview Questions

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,


What is the meaning of decode in informatica?

0 Answers  


What is a mapplet/worklet in informatica?

0 Answers  


State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  






What are the designer tools for creating transformations?

0 Answers   Informatica,


i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,


What is rank transformation in informatica

0 Answers   Informatica,


how much memory (size) occupied by a session at runtime

4 Answers   Wipro,


what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,


How can you differentiate between powercenter and power map?

0 Answers  


what is a time dimension? give an example?

2 Answers   IBM,


Categories