how can one eliminate dupliacte data with out using
distinct option?
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
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Sequence generator, when you move from develoment to production how will you reset
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
During the running session, output files are created by informatica server. Enlist few of them.
What is joiner change?
Differentiate between a database and data warehouse?
How identifying bottlenecks in various components of informatica and resolving them?
How to generate sequence numbers without using the sequence generator transformation?
Explain pmcmd command usage in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to generate sequence numbers using expression transformation?
EXL informatica Questions
Can we change Dynamic to Static or Persistent cache? If so what happens?
Differentiate between reusable transformation and mapplet.
What does role playing dimension mean?