How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
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 |
when we use dynamic lookup,if condition matches what will be the o/p?
can we override a native sql query within informatica? How do we do it?
What are mapping parametres and variables in informatica?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
How does a rank transform differ from aggregator transform functions max and min?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to extract sap data using informatica?
Write the unconnected lookup syntax?
if soource is having 10 records how will u insert 20 records to target
How do you convert single row from source into three rows into target?
Mention few advantages of router transformation over filter transformation.