Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone know that what is the Source File limitation in
Informatica?
To be more precise ..
how many flat file we can use as a source in a mapping if..
1) The Structure of flat files are same
&
2) If the Structure of flat files are different.
Please explain the procedure also if it dosn't bother one much!!
- 2 Answers
- 7752 Views
- I also Faced
- E-Mail Answers
Answer Posted / rana
There is not limitation of source in informatica, but there
is limitation in workspce in warehouse designer.
If there is more Flat file having same streucture then use
inbdirect approach to load.
If there is more Flat file but with not same structure then
you will have to create the process.
let me know if you still any pblm
Rana
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Enlist the tasks for which source qualifier transformation is used.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How would you join a node to the already existing domain?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain pmcmd command usage in informatica
Explain your project of banking domian.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Define the various join types of joiner transformation?
Explain the etl program with few examples.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
