What is the Hierarchy of DWH?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is the difference between informatica 7.0 and 8.0?
How the informatica server sorts the string values in Rank transformation?
What is data transformation manager process?
What differs when we choose the sorted input for aggregator transformation?
how to import multiple flat files in to single target where there is no common column in the flat files
major difference between normal loading and bulk loading?
What are the different versions of informatica?
What is power center repository?
How many dimensions are there in informatica?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?