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
- 7797 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
what is difference between mapping and mapplet ?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
What is a filter transformation?
From where we can start or use pmcmd?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
What are limitations of joiner transformation?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can you use one mapping to populate two tables in different schemas
enterprise datawarehouse your project phase by phase explain?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Teradata 
