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
- 3524 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 difference between copy object import objects using repositery manager which one is best
Explain the different lookup methods used in informatica?
what is update strategy transformation ?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
What is deployment group?
how will you remove the duplicate records from flat file without using sorter?
Useful UNIX commands regular/frequently used
daily how much amount of data send to production?
what is the process of target load planing?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Teradata 
