Interested to Buy Any Domain ? << Click Here >> for more details...
how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 18737 Views
- I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
SD---S.Q----EXP t/r------TGT.
add two port in exp t/r.
one is variable port v_seq expression:seq+1
one output port o_seq expression:v_seq
required ports connect to target.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How identifying bottlenecks in various components of informatica and resolving them?
How to load data in informatica ?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the different lookup cache(s)?
How union transformation is used?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to elaborate powercenter integration service?
What is joiner transformation in informatica?
can u any challenge your project?
What is the function of union transformation?
What is a dimensional model?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What do mean by local and global repository?
What do you mean by filter transformation?
