TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
Answer Posted / mubbasir
This can be done by passing all ports to an expression
transformation and then creating a output port say ID=1 in
both the expression transformation of each file and then
join it using a joiner on ID,hope this helps..
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
how tokens will generate?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Where are the source flat files kept before running the session?
What are the mapping parameters and mapping variables?
What is a standalone command task?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is the hint? how to use it to reduce the query processing in program?
Explain the shared cache and re-cache?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the restrictions of union transformation?
What is substr in informatica?
Slowly changing dimensions, types and where will you use them
What is an unconnected transformation?