Total Answers Posted # 11
Total Answers Posted for My Questions # 9
Total Views for My Questions # 21485
Users Marked my Answers as Correct # 32
Users Marked my Answers as Wrong # 17
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
IBM,
6 Informatica 8610If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
1 Informatica 7483My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
2 Informatica 5392
I am getting five sources in a day and i donot know when i
get them. i need to load data into the target and run the
session. but here i can't keep the session in running or
can't stop the session. plz help me
Answer
status.
| Is This Answer Correct ? | 0 Yes | 0 No |
how can we load first and last record from a flat file
source to target?
Answer
create a port in expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
th record.create 2 condition in in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row).connect both to target.dont forget to give reset
option in SEQ generator.
| Is This Answer Correct ? | 1 Yes | 9 No |
Question { 9047 }
I have a flat file, in which i have two fields, emp_id,
emp_name. The data is like this,
emp_id,emp_name
101,soha
101,ali
101,khan
102,siva
102,shanker
102,reddy.
how to merge the names so that my output is like this
Emp_id Emp_name
101 Soha ali kahn
102 siva shenkar reddy
please provide solution
Answer
SRT - Sort by column col1.
EXP - empid
name
v_name=iif(v_empid=empid,v_name||','||name,name)
v_empid=empid
o_empid=v_empid
o_name=v_name
After this we can use aggregator t/r to take last row for a
particualr emp id using LAST.
| Is This Answer Correct ? | 4 Yes | 0 No |
SRC1 -> EXP -> AGGR ->
TGT
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
Answer
me why keeping AGGR in 1st pipeline makes in invalid
mapping.Thanks in advance
| Is This Answer Correct ? | 2 Yes | 0 No |
SRC1 -> EXP -> AGGR ->
TGT
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
Answer
This is not the right place to do marketting.
Here we share our technical issues and resolve the same.
There are many other ways to attract people for your
institue.
Please do not repeat such malfunctioning.
| Is This Answer Correct ? | 3 Yes | 1 No |
Question { 4223 }
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO
RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ?
HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND
SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND
EMAIL . PLZ HELP ME ...
Answer
from bad file and load into a flat file.In post session
command of new session you can call a shell script which
checks flat file for non zeror records and send email
accordingley.If record count in flat file is non zero it
should send an email.
| Is This Answer Correct ? | 1 Yes | 2 No |
1,If there are 3 workflows are running and if 1st workflow
fails then how could we start 2nd workflow or if 2nd
workflow fails how could we start 3rd workflow?
Answer
create and workflow with these worklets and create
dependency. 2: Use a scheduling tools such as control M or
Autosys JIL to create dependency among workflows.
| Is This Answer Correct ? | 2 Yes | 3 No |
we have 30 wf with 3 batches means 1batch=10 wf
2 batch=10-20 wf
3batch=20-30wf through unix
First you have to complete batch ofter second batch have to
run how can you do in unix?
Answer
then use conditional statement in script to schedule next
batch of workflows.
| Is This Answer Correct ? | 1 Yes | 0 No |
how to return multiple columes through through un-connect
lookup?
Answer
are using unconnected lookup.In override SQL of lookup use
f_name||~||m_name||~||l_name you cna easily get this value
using unconnected lookup in expression.use substring
function in expression transformation to separate these
three columns and make then individual port for downstream
transformation /Target.
| Is This Answer Correct ? | 15 Yes | 0 No |
Question { 5227 }
In Which scenario did u used Incremental loading?
Answer
updated in source.This happens in mainly transactions where
amount or balance changes.This record is flagged based on
the the date colum which isnow changed and value become
greated then session run time when it was executed
previously.
| Is This Answer Correct ? | 2 Yes | 0 No |
my table contain duplicate Records i wanna load uniq records
to my table . i have to pass the uniq records through
filter t/r how?
Answer
unique records in the proprrties of sorter,This will [ass
only unique record from the sorter.
| Is This Answer Correct ? | 1 Yes | 2 No |
