Interested to Buy Any Domain ? << Click Here >> for more details...
Without using any transformations how u can load the data into
target?
- 15 Answers
- 24798 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shiva
simply connect source to target
but be very careful with the connections from source to
target
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / sree
at the time of draging source in to workspace it will auto
matically genartes sq t/r from this u connect to target
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / suren
yes it possible without using any transformation ,mappinf from sq to target .
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / gaurav rustogi
Simply connected souce with target.
If any condition is there we can put in the Source Qualifier
| Is This Answer Correct ? | 1 Yes | 4 No |
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explian the Process of deployment groups in informatica
Is there any target staging area in informatica not staging area
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Two Default User groups created in the repository are ____ and ______
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
server hot-ws270 is connect to Repository B. What does it mean?
who to split dimentions into sub dimention
What is the procedure to load the fact table.Give in detail?
Can we override a native sql query within informatica?
expain about the tune parameters?
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.
Teradata 
