Can we use more than one parameter file in a workfow? If yes, how? If No, Why?

ishan

• Nov 1st, 2015

Yes, we can. In case of concurrent execution of workflow. Go to workflow, properties, there is a option of concurrent execution. In case we enable it we have an option of running multiple instances of workflow using different parameter files.

Answer Question  Select Best Answer

Performance wise which is better connected or unconnected lookup transformation?

priya

• Jan 13th, 2016

Connected and unconnected lookup depends on scenarios and performance. If you are looking for a single value for look up and the value is like 1 in 1000 then you should go for unconnected lookup. Perf...

Answer Question  Select Best Answer

My source records have nulls. How to create dynamic file name?

SHYAM

• Mar 7th, 2016

Create a new field in EXP TRF NAD Hard Code the Value based upon the data in your source.

Example: IIF(ISNULL(COLA),FILENAME,VALUE).
This FILENAME will be given to the text TARGET where DATA which has nulls.

Similarly go for different scenarios.

Answer Question  Select Best Answer

How to convert date format 09-aug-79 to 08-09-1979? I am not able to convert it into 1979 in my case it gives me either 0079 or 2079.

Prasad

• Mar 10th, 2016

To_date(to_char(09-aug-79,dd/mm/yy),dd-mm-yyyy)

Answer Question  Select Best Answer

What is main difference between dynamic lkp and static lkp with example? Performance wise which one is better?

Prasad

• Mar 8th, 2016

Cache can change at run time in Dynamic cache LKP, Performance wise Static LKP is better

Answer Question  Select Best Answer

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

1) 5 fields are in the index cache and 3 are in the data cache.
2) 2 fields are in the index cache and 3 fields are in the data cache.

Anil

• Jun 22nd, 2016

According to Informatica regulations index cache built the cache for conditional ports and non-conditional ports are cached into data cache so answer is 2 in index and 3 in data cache

Answer Question  Select Best Answer

I am loading records from a source table to a CRM target table. I want to get the details of the manually inserted, updated, deleted records from the target table. Please explain in detail.

Nilesh Hajare

• Sep 22nd, 2016

You can check the user id column of CRM object.

Answer Question  Select Best Answer

I am not able to understand the different between PreSql in Source Qualifier and PreSQL in Target in Informatica. I read many other posts they told

pre SQL means " SQL statement executed using the source connection,before a pipeline is run" and post SQL means " SQL statement executed using the source connection,after a pipeline is run".

So if all PRESQL run at same point...

Anurag

• Nov 27th, 2017

Pre-SQL in SQ is use to run the SQL in source database and similarly preS-QL in target for target DB.
This is useful when the source and target database are different .

Answer Question  Select Best Answer

How to create a session log as a parameter in informatica cloud?

sailaja

• Oct 23rd, 2017

At session level if we click on general option you will find session log file, session log folder. We can perameterise those. (ex: $session log file)

Answer Question  Select Best Answer

Assuming that the master pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation.then How many fields are in the index and data cache files?
options:
a. 5 fields are in index and 3 in data cache
b. 3 fields are in index and 2 in data cache
c. 2 fields are in index and 3 in data cache
d....

Prithu

• Aug 27th, 2018

The answer sld be C

Answer Question  Select Best Answer

Suppose in Informatica a source file has 1 column(CITY) and datas are Pune, Kol, Pune. Want to load CITY data to dynamically generated target file(means it will create 2 targets, named Pune and Kol and in Pune target, value will be Pune and in Kol target, value will be Kol) ?

Priyanka Kumari

• May 24th, 2018

use this flow: sorter (on city) -> Expression (compare the current and previous cityname and based on that create the FLAG in another Variable port.) -> Transaction Control (IIF FLAG = 1, TC_COMMIT_B...

Answer Question  Select Best Answer

Why we use joiner transformation to update records in a flatfiles?

Sanket Kamble

• Oct 15th, 2020

Flat file cannot be updated but it is always overwritten

Answer Question  Select Best Answer

Various types of aggregation are SUM, AVG, COUNT, MAX, MIN, FIRST, LAST, MEDIAN, PERCENTILE, STDDEV, and VARIANCE.

Read Best Answer

Editorial / Best Answer

sithusithu  

 Profile Answers by sithusithu Questions by sithusithu

• Member Since Dec-2005 | Jan 19th, 2006

---

• AVG
• COUNT
• FIRST
• LAST
• MAX
• MEDIAN
• MIN
• PERCENTILE
• STDDEV
• SUM
• VARIANCE

Cheers,

Sithu

svivekananda

 Profile Answers by svivekananda Questions by svivekananda

• Jun 26th, 2010

Sum, Count, Average, Median

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

AVG COUNT FIRST LAST MAX MEDIAN MIN PERCENTILE STDDEV SUM VARIANCECheers,Sithu

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: Deb

• Jun 8th, 2005

---

I am providing the answer which I have taken it from Informatica 7.1.1 manual, 
 
Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and carry out workflow tasks.When the PowerCenter Server runs a workflow, the Load Manager performs the following tasks: 
 
1. Locks the workflow and reads workflow properties. 
2. Reads the parameter file and expands workflow variables. 
3. Creates the workflow log file. 
4. Runs workflow tasks. 
5. Distributes sessions to worker servers. 
6. Starts the DTM to run sessions. 
7. Runs sessions from master servers. 
8. Sends post-session email if the DTM terminates abnormally. 
 
When the PowerCenter Server runs a session, the DTM performs the following tasks: 
1. Fetches session and mapping metadata from the repository. 
2. Creates and expands session variables. 
3. Creates the session log file. 
4. Validates session code pages if data code page validation is enabled. Checks query 
conversions if data code page validation is disabled. 
5. Verifies connection object permissions. 
6. Runs pre-session shell commands. 
7. Runs pre-session stored procedures and SQL. 
8. Creates and runs mapping, reader, writer, and transformation threads to extract,transform, and load data. 
9. Runs post-session stored procedures and SQL. 
10. Runs post-session shell commands. 
11. Sends post-session email.

raju4dw

 Profile Answers by raju4dw Questions by raju4dw

• Aug 6th, 2010

Load Manager is responsible for dispatching the sessions and maintains Q of sessions based on first in and first out. Load Manager is also known as Master Processor (DTM) Data Transformation Manager.D...

Deb

• Jun 8th, 2005

I am providing the answer which I have taken it from Informatica 7.1.1 manual,  Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation...

Improve Answer

Two ways 1. Edit the definition 2. Reimport the defintion

Read Best Answer

Editorial / Best Answer

Sumithav29  

 Profile Answers by Sumithav29 Questions by Sumithav29

• Member Since Jun-2009 | Jun 12th, 2009

---

1. If you want to make minor changes to the source definition, you can edit the source definition (in source analyzer) then the Designer propagates the changes to all mappings using that source.
2. If the source changes are significant, re-import the source and giving replace option while re-importing will reflect the changes in all the mappings where the source is used.

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 12th, 2009

1. If you want to make minor changes to the source definition, you can edit the source definition (in source analyzer) then the Designer propagates the changes to all mappings using that source.2. If ...

gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 30th, 2006

in 2 ways we can do it  1) by reimport the source definition   2) by edit the source definition

Improve Answer

Read Best Answer

Editorial / Best Answer

sithusithu  

 Profile Answers by sithusithu Questions by sithusithu

• Member Since Dec-2005 | Jan 20th, 2006

---

Normalizer transformation.
Normalizer transformation which is used to normalize the data.Since COBOL sources are often consists of De-normalized data.

ramonasiraj

 Profile Answers by ramonasiraj Questions by ramonasiraj

• Jul 17th, 2008

Normalizer transformaiton which is used to normalize the datasirajdeen

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 20th, 2006

Normalizer transformation. Normalizer transformation which is used to normalize the data.Since COBOL sources are often consists of De-normalized data.

Improve Answer

Master and detail source Type of join Condition of the join

ORAINFO

 Profile Answers by ORAINFO Questions by ORAINFO

• Nov 20th, 2008

There are number of properties that you use to configure a joiner transformation are: 1) CASE SENSITIVE STRING COMPARISON: To join the string based on the case sensitive basis. 2) WORKING DIRECT...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 20th, 2006

 Master and detail source Type of join Condition of the join the Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full OuterCheers,Sithu

Answer Question  Select Best Answer

The informatica server builds a cache in memory when it processes the first row af a data in a cached look up transformation.It allocates memory for the cache based on the amount u configure in the transformation or session properties.The informatica server stores condition values in the index cache and output values in the data cache.

Puli Ramesh

• Dec 6th, 2006

A LookUP Cache is a Temporary Memory Area which is Created by the Informatica Server. which stores the Lookup data based on certain Conditions.  The Caches are  of  Three types 1) Persistent 2) Dynamic 3) Static  and 4) Shared Cache.

srinivas vadlakonda

• Sep 28th, 2006

Lookup cache is the temporary memory that is created by the informatica server to hold the lookup data and to perform the lookup conditions

Answer Question  Select Best Answer

Normalizer Transformation. When U drag the COBOL source in to the mapping Designer workspace,the normalizer transformation automatically appears,creating input and output ports for every column in the source.

Ramesh Reddy

• Jul 7th, 2014

This is a type an active transformation which allows to read the cobal files....
the cobal source definition associated with normalized transformation....
Use Normalizer T/R to perform data pivote.. the data pivote is a process of converting a single input record into Multiple output records.....

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a ...

Answer Question  Select Best Answer

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. A Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions...

Rksinghpathania

 Profile Answers by Rksinghpathania Questions by Rksinghpathania

• Jun 27th, 2007

Note:- i think the definition and purpose of Router transformation define by sithusithu, sithu is not clear and not fully correct as they of have mentioned <A Router transformation tests data for o...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. A Filter transformation tests data for one condition and drops the...

Answer Question  Select Best Answer