If i have source as flat file. how can i store the header and trilor into one target and data into one more target.
|------>target1(header+trailor)
source------
|------>target2(data)
can any one please help me
No Answer is Posted For this Question
Be the First to Post Answer
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
how to delete duplicate records by using filter transfermation?
what are the transformations that restricts the partitioning of sessions?
Which development components of informatica have the highest usage?
Did u used latest transformations of 8.6.0? for what?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is union transformation in informatica?
Does Facttable Normalized or Denormalized?
Define Update Override?
How to extract sap data using informatica? What is abap? What are idocs?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help