Interested to Buy Any Domain ? << Click Here >> for more details...
How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
- 1 Answers
- 3431 Views
- IBM, I also Faced
- E-Mail Answers
Answer / isha
We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the diff b/w cached and unchaed look ups
Can yoU use the maping parameters or variables created in one maping into another maping?
What is a joiner transformation and why it is an active one?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What are the prerequisite tasks to achieve the session partition?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
What is xml source qualifier transformation in informatica?
What is the sql query overwrite in source qualifier in informatica
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
Teradata 
