Interested to Buy Any Domain ? << Click Here >> for more details...
if i hv 6 table as source table but can i make 12 as a dim
table and 6 as fact table belongs to that src table.
- 0 Answers
- 2179 Views
- iGate, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Partition, what happens if the specified key range is shorter and longer
wht is full process of Information source to target just like stg to productuon and development
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the basic needs to join two sources in a source qualifier?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is mapplet in informatica?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
what is bitmap index? did u use it?and how to use it in informatica
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
What happens if we dont select data driven option?
Teradata 
