Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregation. what is the order that we have to group by?Thanks,Arpita.

Kevin

• Jul 19th, 2023

Database partitioning. The PowerCenter Integration Service queries the IBM DB2 or Oracle system for table partition information. It reads partitioned data from the corresponding nodes in the database....

rajesh_kare

 Profile Answers by rajesh_kare Questions by rajesh_kare

• Oct 21st, 2010

You can define following partition types in workflow manager.1) Database PartitioningThe Integration Service queries the IBM DB2 or Oracle system for table partition information. It reads partitioned ...

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

I have 2 workflows named as W1 and W2 so I need to execute W2 but after W1 workflow executed successfully then only executed W2 workflow? How to do this one?

Venkat

• Dec 22nd, 2022

We can trigger W2 after completion of W1 by using pmcmd commands in shell scripting.

Pranav

• Apr 25th, 2019

Can we not use worklet to add two workflows and link them to run one after the another ?

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: srinvas vadlakonda

• Sep 28th, 2006

---

Source name
Database location
Column names
Datatypes
Key constraints

srikanth

• May 11th, 2022

Column names

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 12th, 2009

ODBC data source, username, owner name, password. Once the connection is established, select the table.

Improve 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

Could not execute action...

The Service Name_repository could not be enabled due to the following error: OBJM_54538 - Unable to connect to the repository Name_repository on database mailto:DESKTOP-4FVDDK@IPC.error: OBJM_54538

Please could you help me with this issue?

Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transformation. Both input pipelines originate from the same Joiner transformation. Either input pipelines contains an Update Strategy transformation. Either input pipelines contains a connected or unconnected...

Tejas

• Jun 7th, 2019

We cannot use Update strategy in a pipeline when using joiner condition, because update strategy has property i.e treat row as which has insert,update,delete, which are processed at runtime, this limit joiner transformation to know exact properties values till runtime, and then proceed further.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

We cannot use Joiner t/r immediately after sequence generator and upd strategy t/r as 1. Joiner will join 2 sources and it cannot join 3rd source as seq generator. Also if we select seq generator as 1...

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

Rupesh Lokhande

• Oct 4th, 2018

1. SQL Override is to limit the number of incoming rows entering the mapping pipeline - Lookup Override is to limit the number of lookup rows to avoid the whole table scan by saving the lookup time ...

sarada

• Nov 28th, 2013

using source qualifier u can extract the data from sources,in over ride u can write the queries to run in the data base,where as in sql t/f u can write and run the queries in database and get the res...

Answer Question  Select Best Answer

Insert Delete Update Update as update Update as insert Update esle insert Truncate table

ankita

• Oct 1st, 2018

Truncate table

Prasanna

• Feb 3rd, 2006

Update as Insert:This option specified all the update records from source to be flagged as inserts in the target. In other words, instead of updating the records in the target they are inserted as new...

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

In a unix environment I have an application that takes several arguments. One of these I get from a session mapping. How do I pass this argument into my application?

Mohan

• Aug 12th, 2018

You can pass the session variable to workflow variable though post session variable assignment and then use the worklow variable as an argument in the command task

Answer Question  Select Best Answer

Mohan

• Aug 12th, 2018

1. You cannot perform DD_Delete unless you have update strategy.
2. While updating a record, ideally created date should not be changed. for that we definitely have to create two targets (insert and update)

vskogirala

 Profile Answers by vskogirala Questions by vskogirala

• Feb 15th, 2008

In update strategy ,1)An insert in the source an insert in the target2)An update in the source is an update in the target update strategy provides 4 types of data driven functions 1)DD_INSERT2)DD_UPDA...

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

set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.

Read Best Answer

Editorial / Best Answer

ManishTewatia  

 Profile Answers by ManishTewatia Questions by ManishTewatia

• Member Since Jul-2010 | Jul 22nd, 2010

---

What Md.Rehman is trying to say is catagorizing the SCD which are the Slowly Changing Dimensions which are used to maintain historical data.

Dimension:A dimension is an organized hierarchy of categories, known as levels, that describes data in data warehouse fact tables

The various types of dimensions are :

1) Shared and Private Dimensions: Describes the basic differences between shared and private dimensions and their uses

2) Regular Dimensions: Provides information about regular dimensions and their variations

3) Parent-Child Dimensions: Describes the creation of parent-child dimensions and identifies their advantages and restrictions

4) Data Mining Dimensions: Describes the creation of data mining dimensions and identifies advantages and restrictions to their use

5) Virtual Dimensions:Describes the creation of virtual dimensions and their advantages and restrictions

6) Dependent Dimensions: Describes the creation of dependent dimensions and identifies their advantages and restrictions

7) Write-Enabled Dimensions: Describes the creation of write-enabled dimensions and identifies their advantages and restrictions

VIKRAM KUMAR

• Mar 1st, 2018

Dimensions are of several types but we use few commonly which are, 1. Confirmed dim. dim. shared by all fact tables. ex- time dim. 2. Slow changing dim. it is of 3 types : SCD1. SCD2, SCD3., 3. Role ...

Venu Gaddam

 Profile Answers by Venu Gaddam Questions by Venu Gaddam

• Dec 23rd, 2010

Dimensions are of 3 types mainly in case of slowly changing dimensions: Type 1 -> Does not maintain any history and is update only. --> this is normal practice mappings.Type 2-> Maintains full histor...

Improve Answer

Chetan

• Mar 2nd, 2018

What if the we have
1,100,Banglore
2,100,chennai
3,100,Mysore
1,101,bangalore
2,101,Kol

Your query will retun 2,3 and we will get
2,100,chennai
3,100,Mysore
2,101,Kol as output

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Sorry for my previous post. I missed a bit of question.

select * from where version in (select max(version) from group by id, loc_no)

Answer Question  Select Best Answer

gen ganesh

• Feb 15th, 2018

Session is one of the task. Task may be session, shell command or email task. When we create task there will be drop down which task should be created. A session is a type of task, similar to other ...

sarita.harsh

 Profile Answers by sarita.harsh Questions by sarita.harsh

• Mar 12th, 2009

Session task: A session task is associated with a mapping. It helps in running the mapping. We need to specify the source and target connections etc in the Mapping tab and configure the properties a...

Answer Question  Select Best Answer

Asha Frank

• Dec 6th, 2017

Reusable and non-reusable

sivaKumar

• Feb 18th, 2017

There are totally two types of session,
1.Reusable session,
2.Non_reusable session,

1.Reusable_session: When you create session under task developer, this is reusable session.

2.Non_reusable_session: When you create session under workflow this is non_reusable session.

Thank you

Answer Question  Select Best Answer

What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?

Read Best Answer

Editorial / Best Answer

sarun5  

 Profile Answers by sarun5 Questions by sarun5

• Member Since Feb-2008 | Mar 13th, 2008

---

Guys I have got the answer for which I asked..here you go

This can be handled by using the file list in informatica. If we have 5 files in different locations on the server and we need to load in to single target table. In session properties we need to change the file type as Indirect.
(Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
When you select Indirect, the PowerCenter Server finds the file list then reads each listed file when it executes the session.)
am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type as Indirect.

Anurag

• Nov 27th, 2017

You should use a indirect file (which contain path and name of all the 5 files) as source. Transformation depends on the business logic.

Ashok Gulagond

• Dec 16th, 2016

When we have the same structured flat files, why don't simply use UNION make them a single file and then load to target instead of such complication? or UNION doesn't work on flat files?

Improve 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