hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
Answer Posted / pooja
write sql query in tgt property .. per sql & post sql
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
Explain what are the different versions of informatica?
How identifying bottlenecks in various components of informatica and resolving them?
What is rank transform?
Sequence generator, when you move from develoment to production how will you reset
Design a mapping to load a target table with the following values from the above source?
can we override a native sql query within informatica? Where do we do it?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
how to load rows into fact table in data warehouse
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the different transaction levels available in transaction control transformation?
What is fact table? Explain the different kinds of facts.
Describe expression transformation?
whats the logic to load the lower level of granularity of data to fact table.
Explain what is informatica metadata and where is it stored?