Interested to Buy Any Domain ? << Click Here >> for more details...
what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
- 3 Answers
- 7127 Views
- I also Faced
- E-Mail Answers
Answer Posted / seshagiri k
By using Target load order plan and based on primary foreign
keys to load the data into n no of dimensions
If it wrong pls send the correct answer to my mail
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain about Informatica server process that how it works relates to mapping variables?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain load alternative records / rows into multiple targets - informatica
What is complex mapping?
where to store informatica rejected data? How to extract the informatica rejected data?
Enlist the differences between database and data warehouse.
What are the different transaction levels available in transaction control transformation?
Explain the difference between mapping parameter and mapping variable?
How to convert multiple rows to single row (multiple columns) in informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain the code page compatibility?
What is flashback table ? Advance thanks
Have you worked with/created Parameter file
