Answer / nagaraju bhatraju

There is a lot of diffrence between informatica an Ab Initio

In Ab Initio we r using 3 parllalisim

but Informatica using 1 parllalisim

In Ab Initio no scheduling option we can scheduled manully
or pl/sql script

but informatica contains 4 scheduling options

Ab Inition contains co-operating system

but informatica is not

Ramp time is very quickly in Ab Initio campare than
Informatica

Ab Initio is userfriendly than Informatica

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---

what is dimension table?

17 Answers  

---

what is incremental data aggregation?

3 Answers   IBM,

---

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

---

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

What is the use of code page?

0 Answers  

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

can we override a native sql query within informatica? How do we do it?

0 Answers  

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---