how to sort date field in infomatica?
Answers were Sorted based on User's Feedback
Answer / ravikumar2614
sorter colomn will stores in sorter t/r, and it will perform will perform the t/r logic based on assending dessending order.
If i am wrong then let me correct by sending on ravi.info2614@gmail.com
Is This Answer Correct ? | 0 Yes | 0 No |
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How can you access the remote source into your session?
How to generate sequence numbers without using the sequence generator transformation?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
How many ways are there to create ports?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
To achieve the session partition what r the necessary tasks u have to do?