Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how do u use sequence created in oracle in informatica?
Explain with an simple example

Question Posted / vijay

Answer Posted / vijay

Using Stored Porcedure Transformation we can call the
Sequence Generator

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

818

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2501

Plz can any one say me how to get the informatica certification materials and dumps

1800

lookup transformation with screenshots

3756

How we can create indexes after completing the loan process?

955

Enlist some properties of sessions.

817

What is a joiner transformation and why it is an active one?

760

what is the size of your data warehousing?

1850

How to improve the performance of a session using sorter transformation?

905

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1851

How to convert multiple rows to single row (multiple columns) in informatica

1121

tell me the rules and responsblites in our project(my project is development)

1702

Explain what transformation and how many are there in informatica?

695

What are the performance considerations when working with aggregator transformation?

896

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

8419