Answer Posted / shivaleela
Dimensional Table:-It contains detailed information of one
Particular department
Eg:-Customer dimension it contains all the information
about the customer like name,place,DOB, city n so on along
with one primary key.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What is the use of source qualifier?
What is the function of aggregator transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Make a note of the quantity vaults made in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Why sorter is an active transformation?
What are multi-group transformations?
Write the prerequisite tasks to achieve the session partition?
How big was your fact table
What is difference between a gateway node and worker node?
Why is sorter an active transformation?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
In warehouses how many schemas are there?
expain about the tune parameters?
How to elaborate powercenter integration service?