Interested to Buy Any Domain ? << Click Here >> for more details...
If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?
- 2 Answers
- 6316 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / deepak aggarwal
No there is no option in informatica for automatic update
of source/target/lookup/stored procedure definition from
DB/file.
Though you can compare source/target/../.. definitions from
existing DB objects and make out if informatica definitions
needs a updation.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / janardhan avula
No..it could not reflect in informatica.informatica is one
of the Dynamic ETL tool using this tool we can design the
the data effectively according to business
requirement..database is different..
I though am i correct.
if u want more info mail me at avula.janardhan@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
.prm wirh repalce .txt is possible?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
How do you load first and last records into target table?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
sorce is a flatfile only 1st and last row should insert to target how will u do?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
enterprise datawarehouse your project phase by phase explain?
how to duplicates from expression transformation without using sorter before that
Teradata 
