Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answers were Sorted based on User's Feedback
Answer / lakshman
Hi,
one more thing flat file is a ODBC whn compare to others
| Is This Answer Correct ? | 0 Yes | 4 No |
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
design of staging area?
Define mapping and session?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
How the informatica server sorts the string values in Rank transformation?
How can yoU create or import flat file definition in to the warehouse designer?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Can we run session without using workflows?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain reference cursor?
What are the different versions of informatica?