Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
Answer Posted / vissu
pls give an example for that
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain about Informatica server process that how it works relates to mapping variables?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How can we use mapping variables in informatica? Where do we use them?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is a repository manager?
What does refresh system mean, and what are its distinctive choice?
What is informatica powercenter repository?
How do you load unique records into one target table and duplicate records into a different target table?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain the aggregator transformation?
What are connected or unconnected transformations?
Define mapping and session?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?