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 37829

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

4 27959

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 13501

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 5450

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

10 27834





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

2 5706

What are the uses of a Parameter file?

3 10098

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

3 11343

when we dont use aggregator in mapping ?

2 4350

How many joins in Informatica

5 19873

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

3 6626

What is router transformation

4 3846

How to eliminate duplicates in FF and oracle both

3 4319

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

2 5023

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 6030

Post New CSC Informatica Interview Questions




CSC Informatica Interview Questions





Un-Answered Questions

Which types of gate insttaled in static switch. Please give me answer.

570


Give full information about infrared technology, like applications, advantages, disadvantages?

40


What are the different types of refreshing data for our published reports?

1


Hi all.... Please explain to me... what G/L account should I maintain / create If I want to do the intercompany transfer asset - no revenue. and if I want to do the intercompany transfer asset - Net Book Value. What is the different between this 2 method. My company's requirement is ... 1. Transfering the asset on company A to company B, example Asset 1 - acquisition date : 01.06.2007 , acquisition amount : 1000, accumulated depreciation till 31.12.2007 : 10 so the net book value is 90, useful life 4 years the company wants to transfer this asset in company B. is it possible to transfer all the data just like I explain above : acquisition date : 01.06.2007 , acquisition amount : 1000, accumulated dep = 10

971


What are the 4 stages of computing?

28






What do I do if the data area is full?

1


What is SSID?

519


How to make Private company into public limited company ?

1245


Where do you set people code trace?

18


Explain anaphylaxis?

9


why and how current drawn by battery charger depends upon the altitude where it is located?

1014


For define what rats and rabbits use their claws?

27


How will you create a new content type using code?

3


How do you install a sphinx python?

23


How splunk helps the enterprise?

14