In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation.
If millions of files are there, how can we enter the flat file names in list file?
Post New Answer View All Answers
Define pmcmd command?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain constraint based loading in informatica
Why do you use Mapping Parameter and mapping variable?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is dimensional table? Explain the different dimensions.
Plz can any one say me how to get the informatica certification materials and dumps
What is the difference between a repository server and a powerhouse?
What is meant by a domain?
r u done any partitions in ur project?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
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 are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the different types of transformation available in informatica.
When do you use sql override in a lookup transformation?