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!!
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 |
Which one is better performance wise connected/un-connected lkp?why?
How to delete duplicate records in a flat file source?
r u done any partitions in ur project?
What is the cumulative sum and moving sum?
What happens if the info. Server doesn't find the session parameter in the parameter file?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
When we are using Dynamic Cache,which options we will select in session level?
Write the advantages of partitioning a session?
State the limitations where we cannot use joiner in the mapping pipeline?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What is the commit type if you have a transaction control transformation in the mapping?