How to kill 10 workflows at a a time ?

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Write 10 pmcmd commands with abortworkflow option in one bat/sh file and execute at once

wanilkumar

 Profile Answers by wanilkumar Questions by wanilkumar

• Oct 7th, 2011

It is not possible to kill multiple workflows at a time. You must Abort/Stop one at a time.

I think starting with the version 8.6 you can run the same workflow multiple times at the same time.

Answer Question  Select Best Answer

What is the structure of the reject file in Informatica?

Ramarao

• Jul 10th, 2012

We need to give the option in target level for rejected data (means needs to give the path of the badfiles to capture the rejected data)

Kiran

• Apr 15th, 2012

There is no predefined structure for bad files. It has the same structure as of the target table.

Answer Question  Select Best Answer

Can we update target table without using update strategy transformation?

MAHESH MANAM

• Aug 22nd, 2012

Yes, By using session level properties. In that use follow the steps Session --> Edit --> Properties --> Treat source rows as --> Update and also you should check options in Mapping --> Target --> U...

pranyarockvi

 Profile Answers by pranyarockvi Questions by pranyarockvi

• Jul 30th, 2012

Yes we can , it is the just that update strategy is used for conditional updates, and the update option available at the mapping level in the target is update without any condition.

Answer Question  Select Best Answer

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Staging area may be required if you have any of the following scenarios: Delta Loading: Your data is read incrementally from the source and you need an intermediate storage where incremental set of y...

MAHESH MANAM

• Aug 16th, 2012

It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...

Answer Question  Select Best Answer

Can any one please tell me how to explain Manufacturing Domain Informatica project in interview as a ETL Developer and from where to start and end.

pradyumna sahoo

• Jan 28th, 2015

Shortly u describe your projects like project name ,& which domain u work? basically u tell your project architecture and its flow .

vijay

• Nov 27th, 2012

Start your project description, then move on to your role and responsibilities and then about your team and so on...

Answer Question  Select Best Answer

Dhiraj Chachane

• Sep 28th, 2017

Hi anybody Can you let me know about how to load flat files to target without mappings?

Sarita

• Oct 23rd, 2013

The daily routines of the developer in support role: 1)Do lights on activity,i.e. check if the informatica services are running,any session failed or not,if a file failed then how many records loaded ...

Answer Question  Select Best Answer

Which means the first record should come as last record and last record should come as first record and load into the target file?

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

In the Sequence generator, write the query and then order by DESC. this will do a reverse of all records first will go last and last will go first.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

This is pretty simple.

Use sequence generator to number the records.

Then sort them in descending order using sorter transformation.

Answer Question  Select Best Answer

Gayathri

• Jul 21st, 2014

Go to Session Properties->Config.Object, Make Stop on Error as 0.
This will not fail the session if there is error in 1 record. This will load all error free records.

Dinesh

• Jul 21st, 2014

If the source is FF, then use skip first 299 rows and then start loading.

If the source is relational then u row number.

Answer Question  Select Best Answer

How to tune the session,workflow for better perfomance,what are the things we consider for better performace?

Ruhi

• Feb 1st, 2016

Partitioning, line sequential buffer length, tracing level as terse, collect performance data as enabled, commit interval are some of the pointers for session level performance tuning.

Rajesh Kumar

• Sep 16th, 2014

Make sure the Sorted Inputs enabled for Joiner, Lookup and Aggregate transformations in workflow.
Use Dynamic cache for lookups whenever needed otherwise cache takes more spaces (instead of cache)

Answer Question  Select Best Answer

Hi All,

I am faced with a scenario wherein while data flow from source to target, a condition would be checked that if the data is present in target then a source column will be updated as U and if the data is not present in target then the source column will be updated as I

Vipin

• Nov 11th, 2014

Lookup the target table based on key and check either record is exist or not. If Lookup returns any record then By using update Strategy update or insert. Note : to update record using Update Strategy you need to apply Primary key at INFA Laval at least otherwise it wont work.

KJ

• Nov 10th, 2014

Its never the source but the target column that gets updated with U or I to identify the updated or newly inserted rows.

Answer Question  Select Best Answer

What is meant by informatica grid? what are the component of informatica grid?

Fabio Mendon?a

• Mar 31st, 2016

When I use a grid in a Workflow and my second session (S2) has distributed on 3 links .... Question: The process that run on link 1 (S1 , S2 , S3 , S4, S5) , get the same link until the end (S5) ?...

Pruthvi S

• Dec 21st, 2014

A grid is an alias assigned to a group of nodes that allows you to automate the distribution of workflows and sessions across nodes. When you use a grid, the Integration Service distributes workflow...

Answer Question  Select Best Answer

Source
id,name
1,a
2,d
3,c

Target
detail
((1/a)(2/b)(3/c))

Manas

• Feb 4th, 2015

We can use expression transformation here in which we can define variables that store the string in the below mentioned way: var1=var1||(||id||/||name||) output_port=(||var1||) After this w...

XYZ

• Feb 4th, 2015

Using a Union Transformation

Answer Question  Select Best Answer

I am new to Informatica and learning it, Can anybody please tell me how we receive source as flat file in informatica? From where we get this flat file?

yusuf

• Feb 20th, 2016

You create a one note in desktop and insert the data with delimiter as you require and save it . Go to source qualifier and import as flat file and import from desktop.

xyz

• Feb 19th, 2016

We need to create the Flat file or import the file if already exists. Source Analyser--> Create or Import file

Answer Question  Select Best Answer

How to load top/last 3 record using parameter file in Informatica?

Anil

• Jun 22nd, 2016

Parameter files are meant to standardize business rules we can specify, from what column the data is to be extracted and loaded but I think it is not possible to load top/last 3 record by parameter file?

janardhanan

• Jun 12th, 2016

Using Rank Transformation

Answer Question  Select Best Answer

Why do we need transformations like filter, sorter, Joiner etc when we can do all those tasks with Source Qualifier itself using queries?

anand

• Jul 15th, 2017

Because of whenever we are getting data from tables then src_quli works, not for filedata

jatin

• Jun 8th, 2017

Its because in source qualifier you can make the transformations like join, filter only with homogeneous sources like tables can only joined with tables. But if you have to join a file and a table the...

Answer Question  Select Best Answer

In SCD Type 2 Mapping, I Have 50 Records. How to compare without going record by record?

DEEKSHA

• Mar 12th, 2019

Use joiner transformation, instead of lookup to target table.

Arpit Gautam

• Nov 1st, 2018

Use MD5 check constraint in Expression transformer

Answer Question  Select Best Answer

How can we do incremental loading if the source is flat file?

Jacqueline

• Aug 23rd, 2023

Ratnesh, your answer is fine if we know what the natural keys are but what happens if the file is extremely large and you have no idea what the keys are in the flat file? If that is the case then I ...

Ratnesh

• Dec 31st, 2020

If your source flat file is always full file , based on the natural keys, you can identify the records by lookup on the target table , whether records are existing or new. If records are new, go ahead...

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