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 44445

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

4 30666

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 16203

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 7192

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

10 31833

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

2 7251

What are the uses of a Parameter file?

3 12090

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

3 13967

when we dont use aggregator in mapping ?

2 5696

How many joins in Informatica

5 22546

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

3 8407

What is router transformation

4 5757

How to eliminate duplicates in FF and oracle both

3 5976

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

2 6482

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 7929

Post New CSC Informatica Interview Questions

CSC Informatica Interview Questions

Un-Answered Questions

Re: Sugar Cane Bagasse What are the 1. Specific Heat of Bagasse at 50% moisture, 40% moisture and 25% moisture? 2. What is bu;lk density of bagasse at 50% moisture, 40% moisture and 25% moisture? 3. What is specific gravity of bagasse at 50% moisture, 40% moisture and 25% moisture? 4. What is the specific heat of flue gases generated from boiler fuelled by bagasse? 5. What is the specific gravity of flue gases generated from boiler fuelled by bagasse?


What is binary tree and its properties?


Mention the differences between the clustered and non-clustered index


Why generics are used in java?


What is repository in php?


What are the ways in which one can know that the given operation is transformation or action?


Explain about compute Grid?


How to Sort Strings which are given in List and display in ascending order without using java api.


What is the most common trace flags used with sql server?


What is the tarif feature? : hr- payroll


What is difference between views and stored procedures?


why you want to do MBA in Indusrial management?


Mention what is ObjectInspector functionality in Hive?


Where is the ribbon located in microsoft word?


What is magnetism?