Відео

#TechTutorials sir can you please help me with the below scenario on informatica pc pls Q: informatica code to delete the records in target which are not present in the source. for example 20 new records loaded in the target in first load. In second load 10 records are coming from source which is already present in the tgt the rest 10 records which are not there in the source but are present in the tgt have to be deleted from tgt. This code has to be made like SCD applying lookup on tgt.

i am facing mapping error "Target definition has more than one Transaction Control point connected to it" pls help

I tried to create files in unix shared path and it worked, but the file doesn't have write access (chmod 777). How to provide chmod 777 to the files that are created dynamically. I know that we can pass the command in post session success command but these dynamically created files are taking name from mapping, how should we mention it?

Hi, one doubt ! why did you map the output that came from the source? we have calculated the new port in the expression, right? shouldn't we map the new output port with the target? if not then how it is working?

Thanks

Could it be that de seq transformation goes from 1 to 2? And then send to odd table those with 1 and to even table those with 2? Could this approach work for the next case where yo have 3, 4 or X number of target tables?

Cant we use sorter after the union to sort the data alphabetically ?

Thanks

may i know what type of questions and at what depth questions will be asked for 12+ years experience

My doubt is , I can get the same result if in the router I can put count=1 , then we don’t need the expr trans and we can join the sorter and the aggregator . I am getting the same result. Please can you help me to understand if there is any problem if we remove the expr ??

Hi,I have tried this scenario but i can only see one out file in target file folder .Other 3 csv files are not getting generated dynamically. Can you please help me what could be the reason for that.

Can you let me know is this same if there is few more columns in source.

3 & 4

Thank you sir it help in my implementation

I think we dont need joiner in this scenario,we can just give count from aggregator to route data

it doesn't work when we are going to add like id-10 val-d id-20 val-g

all my data are loading to middle ..I m not getting any data in header and footer .Can someone pls help me

For join condition can we use next val instead of dummy .Is it possible?

Can you make a video on crack interview of informatica

Hi Without selecting the cycle checkbox and just giving the end value still the nextval gives alternate 1 and 2?

u can use Sequence generator and Expression to A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee Let's assume the input string is named VALUE and the total length is named TOTAL_LENGTH. Then you will need the following additional ports in the EXP: - One variable port v_length, type Integer, with this expression term: Length(VALUE) - One variable port v_pad_val, type String (250), with this expression term: LPAD( SUBSTR( VALUE, 1, 1), 250, SUBSTR( VALUE, 1, 1)) - One output port REPEATED_VALUE with this expression: SUBSTR( v_pad_val, 1, TOTAL_LENGTH)

If a source has 100 rows and last 3 rows needs to be loaded in a separate target, how it can be executed ?

can u pls include a scenario for pyramid triangle data like A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee pls explain the logic to execute this one .not by using normaliser pls

Thanks!!

Thank u sir

Hi,I have created the mapping as you explained and i got the output as expected. I have a doubt we got the output in csv format.is there is any possibility to create the output in tables.

These scenarios are best..

Your video are very great bro 👍👍👍

Très bon

I don't know why ppl not subscribe your video.... Your contents are really great bro 👍👍

We have given sequence as sequence+1 in exp transformation but we didn't define any initial value as sequence =0 to add with 1... Can you explain that ?

as this is implementation of LAG() of SQL .... In this way how we can implement the Lead() functionality of sql in informatica.

It helped me!! Thanks

In case u need to reload from beginning ,How do you reset the mapping variable using script?

Thanks for the clear explanations! I've a question. Can we achieve this scenario by considering flags for duplicate records After sorting? IFF(current_input_data=prev_input_data, 'N', 'Y') A Y B Y B N B N C Y C N D Y And then use Router to direct records with flag Y & N separately. A B C D B B C

I have doubt what will we be the value of pattern at beginning , i 'm unable to decode that iif condition could explain one sample taking rough records in paper

Thank you so much !! It was really helpful.

Hi, In the same way can we create tables in DB dynamically on the fly..?

Sir, what if there are multiple footers? Can we use the same logic?

Nice tutorial.Have one question Input OUTPUT A A B NULL C B D NULL C NULL D NULL How we can achieve this

Hi, I have a scenario like there is one source flat file and target is 3 tables/flat files..so first time all the data should go to table1 and in 2nd run all the data should go to table 2 and in 3 Rd run all the data should go to table 3 and same process has to be repeated ..could you please help me with the solution

No need to give aggregate and joiner, use router and give condition final_count=1. And final_couny>1

Why can't we just use cyclic seq generatr and route fields? Is my approach correct? Like for alternate we will use cyclic seq generatr with values 1,2 We will route the records with 1 into one target and 2 into another target..

Excellent sir. Very good explanation

How to proceed if we have a situation like according to the number of input files the target files should be created?

Why don't you post more videos?

Sir if we take only expression, then how can we generate it? please suggest me. Second this if we consider this only mapping then i have a doubt why we have taken joiner here.

We can use LAG function instead.

If we using group by condition on the newvalue column doesn't it create a single Index for each newvalue column. At the end of aggregator output should be a 1 , b1, c 3 ????and not A1,b1,c1, C2,c3

Thank you!!