can we override a native sql query within informatica? Where do we do it? How do we do it?
No Answer is Posted For this Question
Be the First to Post Answer
how will you get 21 to 30 record from 50 records?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
What are conformed dimensions?
what is upstream and downstream transformation?
How many repositories can be created in informatica?
How many transformations can be used in mapplets.
what is the difference between mapplet & stored procedure?
What is A complex mapping?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
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?