Without using any transformations how u can load the data into
target?
Answer Posted / soujanya
with out using any transformation we can directly load the
data to target this is known as SIMPLE PASS MAPPING. when
we drag the source to workspace the source automatically
generates source qualifier and from source we can connect
to target. In case of cobol files we use the normalizer
transformation. and remember source qualifier is also a
transformation rite.
soujanya mentay
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we can create indexes after completing the loan process?
Explain the types of transformations?
How do you load only null records into target?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to load a Dimension ? and how to load a fact table?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How union transformation is used?
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?
What is sq transformation?
How to generate sequence numbers without using the sequence generator transformation?
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 .
What is a connected transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is sorter transformation?
can we override a native sql query within informatica? How do we do it?