can every transfomation reusable?how?
Answers were Sorted based on User's Feedback
Answer / vijay
except source qualifier tranformation,all transformations
supports reusable property.reusable transformation
developed in two ways.
1.in mapping which transformation do you want to re
use,select the tranformation and double click on it,there
you got option like make it as reusable transformation
option.there you need to check the option for converting
non reusable to reuasble transformation.but except for
source qualifier trans.
2.by using transformation developer
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / usha
every transfomation reusable is reusable except source
qualifier tranformation..
if we create transformation in transformation developer its
reuasable
| Is This Answer Correct ? | 2 Yes | 0 No |
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
how to import multiple flat files in to single target where there is no common column in the flat files
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
how to we create datamart?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
What is enterprise data warehousing?
Sequence generator, when you move from develoment to production how will you reset
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
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.