What is the surrogate key?
No Answer is Posted For this Question
Be the First to Post Answer
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is pmcmd command?
What are the different types of olap? Give an example?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
explain about session partitions ?
what is degenerated dimension?
What is the difference between normal and bulk loading? Which one is recommended?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
Which one is better performance wise connected/un-connected lkp?why?
What are Dimensions and various types of Dimensions?
What are the types of schemas we have in data warehouse.