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

How to merge First Name & Last Name?

8 Answers  


What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  


what is difference between dimention table and fact table?

1 Answers  


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  






Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


Why we use lookup transformations?

1 Answers  


WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  


how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,


What is aggregate awareness?

1 Answers  


what is mystery dimension?

1 Answers  


Categories