How to do unit testing in informatica?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
What is confirmed dimension and fact?
How will u find weather dimension table is big in size of a fact table?
sample mappings for scd1,scd2 and scd3
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
what is the diff b/w cached and unchaed look ups
Enlist the differences between database and data warehouse.
Describe two levels in which update strategy transformation sets?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?