How to Explain My project flow,In TCS ased me this question.
In which way i can start my project flow and they asked how
many fact tables and dimensional tables u used. Can any one
Explain Briefly for this question and project architecture
also.. please..
Answer Posted / smarati
Explain the different mappings you developed, which meets
the business requirements.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain sessions?
What is union transformation in informatica?
Is there any target staging area in informatica not staging area
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is an aggregator transformation?
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
Explain the different kinds of facts.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How do you promote a non-reusable transformation to reusable transformation?
What is source qualifier transformation in informatica?
Explain in detail about scd type 1 through mapping.
What is difference between a gateway node and worker node?
What does “tail –f” command do and what is its use as an Informatica admin.