Interested to Buy Any Domain ? << Click Here >> for more details...
Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?
- 1 Answers
- 4696 Views
- I also Faced
- E-Mail Answers
In case a table is getting changed constantly,... u need to
make a lookup of the target table with the source table.
and put an incremental load logic. If you want the logic I
can explain this anytime. :)
| Is This Answer Correct ? | 0 Yes | 1 No |
What is lookup table in etl testing?
What is the difference between Data Warehousing and Data Mining?
What are three tier systems in etl?
dimension object created in oracle can be imported in designer?how?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
when should one create lookup transformation ?
What is data cleaning?
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.
what is session partitioning?
What are cubes and olap cubes?
WHY CANT WE SEE THE DATA IN DATASET
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Teradata 
