TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
Answer Posted / kalyan
How abt using full outer join in the type of join in the
joiner Transformation.
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
In development project what is the process to follow for an etl developer from day1
What are roles and groups and benefits of using them?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How does a sorter cache works?
Implementation methodology
What is rank transformation?
Explain sessions and how many types of sessions are there?
What are the types of data warehouses?
what is unit testing?tell me proceedure
How to extract sap data using informatica? What is abap? What are idocs?
What is the difference between router and filter?
explan ur project architecture?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are different types of transformations available in informatica?
What is pmcmd command?