Explain sql transformation in script mode examples in informatica
No Answer is Posted For this Question
Be the First to Post Answer
How to merge First Name & Last Name?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
what is difference between dimention table and fact table?
How to prepared lld.can any one tell me detailed explanetion.
What is the difference between source qualifier transformations source filter to filter transformation?
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?
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????
Why we use lookup transformations?
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 ...
how we can load rejected record's at run time?(not through bad files)
What is aggregate awareness?
what is mystery dimension?