If you have 10 mappings designed and you need to implement
some chages (may be in existing mapping or new mapping need
to be designed) then how much time it takes from easier to
complex?
Answer Posted / elango
It depends on the complexity of resuablity or re-mapping
based on the client specification.
So this question is to check whether r u smarter enough to
understand the existing mapping and design new ones.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain target update override in informatica
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?
How union transformation is used?
In how many ways we can create ports?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
explain abt ur project architecture?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Whats there in global repository
Explain in detail about scd type 1 through mapping.
What are the types of data warehouses?
What are the types of schemas we have in data warehouse.
Does an informatica transformation support only aggregate expressions?