Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




CSC Informatica Interview Questions
Questions Answers Views Company eMail

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 37378

In real time scenario where can we use mapping parameters and variables?

4 27787

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 13365

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 5376

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 27443





How to generate a single mapping for both the historical and incremental load.

2 5644

What are the uses of a Parameter file?

3 9978

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 11181

when we dont use aggregator in mapping ?

2 4286

How many joins in Informatica

5 19727

How to identify this row for insert and this row for update in dynamic lookup cache

3 6537

What is router transformation

4 3772

How to eliminate duplicates in FF and oracle both

3 4272

If I am having 6 flat files in data. How can you load the data at a time

2 4947

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 5928

Post New CSC Informatica Interview Questions




CSC Informatica Interview Questions





Un-Answered Questions

i am new to this tax system if you don't mine "please help me"

926


Hi, Can anyone proivde the soluiton for the below senirio, thanks in advance. We are providing test services to various sites of a corporate. Now, we want to bill as a single bill point i.e. Corporate office. Single bill for each site will be generated. E.g. Panac Labs, New Delhi Head Office Panac Labs, Mumbai Lab at Mumbai Panac Labs, Kolkata Lab at Kolkata Panac Labs, Indore Lab at Indore In above case, we are cattering services to all four locations. However, New Delhi is the Head office and Lab too. Hence we will issue four bills addressed to Panac Labs, New Delhi. Outstanding and debtors will be maintained on A/c of Panac Labs, Head office. We also want to maintain sub- ledger base on sites

941


List the qualities of useful market segments?

26


What are the uses of alloys in daily life and how are alloys made?

36


What are different access specifiers in java?

17






What are the renewal types?

696


describe a recent unpopular decision you made.

25


Define dml compiler.

15


Explain a linkage segment

12


Hi, Is there any smart plant instrumentation design training institute in Bangalore?

504


where do you see yourself 5 years from now

17


What are all the components of sap xapps?

27


how to increment dates by 1 in mysql? : Sql dba

19


What do location update mean? Why do we need them?

15


What support will I have in using the success factors?

1