Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 5 Answers
- 16480 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek kumar
using union transformation.........
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is Forward,Reverse and Re_engineering?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Is apache nifi an etl tool?
how does the server recongnise the source and target databases.Elaborate on this
Difference between flat files and relational sources?
Explain about the data integration suite features?
what is Forward,Reverse and Re_engineering?
How many steps etl contains?
What is grain of fact?
Identifying the bottlenecks in various components of Informatica and resolving them.
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what is data modeling?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Two default user groups created in the repository are____and_____.
