Interested to Buy Any Domain ? << Click Here >> for more details...
what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
- 3 Answers
- 11642 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash
Expression tranformation is used in data cleansing.
If ur target table consist of not null column and source
table consisting null columns so assign some value in
expression tr.
and then pass data to target.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shashiall
Source Qualifier Transformation and Expression
Transformation are used for Data cleansing.
Data types ,Date formats,null ..not null
constraints ..these r main things considered in the data
cleansing.
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi Friends,
My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the necessity to use update strategy?(except for updates)
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
lookup transformation with screenshots
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
What is the difference between a router and a filter transformation?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
Explain the pipeline partition with real time example?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
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 are variable ports and list two situations when they can be used?
Teradata 
