how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 10050 Views
- Patni, Wipro, I also Faced
- E-Mail Answers
Answer Posted / prabha kamaraj
Using Group by command removes all duplicates records in a
table
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
How to create the source and target database connections in server manager?
is it possible to index the data in cache of lkp transformation ?
How to create a non-reusable instance of reusable transformations?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is an unconnected transformation?
What is data movement mode in Informatica and difference between them?
What is the use of code page?
What is xml source qualifier transformation in informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
generate date / time dimension in informatica
What is a stored procedure transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is the difference between stop and abort in informatica
