If I am having 6 flat files in data. How can you load the
data at a time
Answers were Sorted based on User's Feedback
Answer / sankar
for that 6 flat files make a one list file,then enter the
that 6 flat file paths in list file.
then session level select the type: inderect path:list file
patha filename:list
Is This Answer Correct ? | 21 Yes | 0 No |
What is informatica?
What is the fact table?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain pushdown optimization and types in informatica
How to Create a folder using pmrep command?
Why use shortcuts(Instead of making copies).
Where is the cache stored in informatica?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
what is a time dimension? give an example?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,