which T/r we can use it mapping parmeter and mapping
variable? and which one is reusable for any mapping mapping
parmeter or mapping varibale?
Answers were Sorted based on User's Feedback
Answer / x
Hi,
All T/R's which we give conditions,their we have an option
of 'variables' here we can use this mapping parameters &
mapping variables mapping parameters are reusable
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bsgsr
i believe it is seq gen, filter, expression in which v can
use mapping parameter and variable.
mapping parameter is reusable. v simply change the value of
the parameter in the parameter fle.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / vijayb
What is T/r..?? is it Transformation..!!
If ur asking about transformation then Lookup Cache (named
and un-named) is a transformation which we can use in a
multiple mapping and also in same mapping in different
lookup.
| Is This Answer Correct ? | 1 Yes | 5 No |
why dimenstion tables are denormalized in nature ?
What is data transformation manager process?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
in a table it has 200 rows the query is select 150 from tablename.whats the output
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
How You Pull the records on daily basis into your ETL Server.
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
what is unique constraint error ?
What are Dimensions and various types of Dimensions?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.