What are the different types of schemas?
Answer Posted / ramesh
schems are two types one is star schema and another one is
snow flake schema
| Is This Answer Correct ? | 6 Yes | 14 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are Dimensional table?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a connected transformation?
Explain target update override in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How many number of sessions can one group in batches?
What are the differences between oltp and olap?
Explain the code page compatibility?
How to extract sap data using informatica?
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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the differences between source qualifier and joiner transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain lookup transformation source types in informatica