Interested to Buy Any Domain ? << Click Here >> for more details...
Without using any transformations how u can load the data into
target?
- 15 Answers
- 25107 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 |
in which situations do u go for starflake schema ?
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
How to import oracle sequence into Informatica?
What is mapping debugger?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
what is the command to get the list of files in a directory in unix?
What is an aggregator transformation? it is active why cant it be passive explain?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Teradata 
