Answer Posted / chansra
if source having duplicate rows then we can use
dynamic...otherwise we can use static
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
Target increases every day even though no new record was inserted
How to delete duplicate row using informatica?
What is data movement mode in Informatica and difference between them?
What is the function of union transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How would you copy the content of one repository to another repository?
How do you load only null records into target? Explain through mapping flow.
What is meant by pre and post session shell command?
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
How to extract the informatica rejected data?
Have you worked with/created Parameter file
Is it possible to use a client with different version than that of its Informatica server?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
how to create user defined function (udf) in informatica