what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
Answer Posted / 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 |
Post New Answer View All Answers
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are pre and post-session shell commands?
how we can load rejected record's at run time?(not through bad files)
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
write a query to retrieve the latest records from the table sorted by version(scd)
Please let me know how to make Data masking in informatica..
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What will be the approach?
State the differences between sql override and lookup override?
What is meant by lookup transformation?
What is informatica powercenter repository?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Define filter transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.