Відео

Please increase the audio volume. Its difficult to hear and zoom the screen bit.

how the connection identifies the target without mentioning the hostname or port or something?

Tq

Great overview!

Dear Sir: My trial is going to expire on June 10,2024 based on the notifications forwarded to my email account on today. Please tell me when I can start my luck because there are 50 assets are there getting scare to be lost. Your further guidance is always appreciated. Sincerely Yours, Muhammad Khan from North America

Hi, how to implement file encryption using file processor in iics?

Can we compress file and transferred to external server ?

what is the difference between completely parameterize and partially parameterize

super it works for me.......

Hi, how can I get all mappings from old iics account into new account if old account expired... Please respond me, what should I do..

sir, input parameter - fixed value during task/task flow run?

Thanks i have same issue which is resolve from your guidence

you got a subscriber sir.

what a clear explanation sir 🤗 please upload more.

Hi, have you used the synchronization task to upload a specific file that contains YYYYMMDD pattern for example? I have search for an example, but I still don't know how to use that option.

Great contribution. Pl keep it up.

After free trail account it will work

Hi sir, how to contact you ? Need small help in understanding my project requirements

Thanks ETLGuru for the videos. When we use parameterized connection from parameter file in IICS, will I be able to perform any calculation/expression if I don't know the incoming port names How can we work on this during migration to iics if we have used parameterized connection in powercenter

Annoying music, no explanation :l

Here we are using sequence genartor 1 run igot 1 to 5 number after second run i got again 1 to 5 in type 2 we unique to key value but ididnt got how i got unique numbers

In Target connections it's not showing any option to choose from. How to fix that?

How to explain iics migration Project in interviews

I need this

Any informatica PC proxy person available in hyd pls DM me

Nice explanation. Your voice was too low

This can easily be done with max function and using partitioning it

Excellent video. Thanks !!

Excellent video. Thanks !!

Super

Super.... Please make video on partitions

Thank you sir

Can you please create a videos how to access cloud repository database using rest api and pull the run statistics and load to a table

Nice one.. please do post new videos' on IICS.... Thanks.

Do u have datastage videos? Pls upload.

I am getting the end_date as today's date in up_insert operation. I have done same as yours and even cross-checked

From where v_CNT took reference in expression transformation ? I mean Without input ports how v_CNT calculating

Thanks For Videos.. Could you please post some videos like connecting to S3 to read and load data from IICS

Good, will u tell the SCD type 1

Nice explanation, it will help many...

Error in expression for TO_DATE('31-12-9999','DD-MM-YYYY') in end date is showing! not equivalent to mysql date type

Thanks for the Video / Good Job Keep it up

sql query??

Thanks for sharing

Hey man, glad to meet again. I have only a simple enquiry as a new sql learner. How order by clause differs from rank function in sql? Thanks for taking care of this.

The first 3 Records are in T1, the Next 5 Records in T2 and the Rest in T3 SRC->SQ->EXP->RTR-TGT1,2,3 EXP ----- v_CNT=v_CNT+1 CNT_1_3 = IIF(v_CNT<=3,1,0) CNT_4_8=IIF(v_CNT>=4 AND v_CNT<=8,1,0) RTR ____ Groups Group_Target1=CNT_1_3----->T1 Group_Target2=CNT_4_8----->T2 Default1------->T3

Meta Data for practice ------------------------------------ CREATE TABLE SALES(ORDERNO NUMBER(10),P_AMOUNT NUMBER(10,2), ORDERDATE DATE, CUST_ID NUMBER(10)); INSERT INTO SALES VALUES(70001,150.5,TO_DATE('2012-01-05','YYYY/MM/DD'),3005); INSERT INTO SALES VALUES(70009,270.65,TO_DATE('2012-03-05','YYYY/MM/DD'),3001); INSERT INTO SALES VALUES(70002,65.26,TO_DATE('2012-12-05','YYYY/MM/DD'),3002); INSERT INTO SALES VALUES(70004,110.5,TO_DATE('2012-10-06','YYYY/MM/DD'),3009); INSERT INTO SALES VALUES(70007,948.5,TO_DATE('2012-05-06','YYYY/MM/DD'),3005); INSERT INTO SALES VALUES(70005,2400.6,TO_DATE('2012-10-07','YYYY/MM/DD'),3001); INSERT INTO SALES VALUES(70008,5760,TO_DATE('2012-08-07','YYYY/MM/DD'),3002); INSERT INTO SALES VALUES(70010,1983.43,TO_DATE('2012-07-07','YYYY/MM/DD'),3004); INSERT INTO SALES VALUES(70003,2480.4,TO_DATE('2012-10-07','YYYY/MM/DD'),3008); SELECT * FROM sales; ------------------------------------------------------------------------ ORDERNO P_AMOUNT ORDERDATE CUST_ID 70001 150.5 05-01-12 3005 70009 270.65 05-03-12 3001 70002 65.26 05-12-12 3002 70004 110.5 06-10-12 3009 70007 948.5 06-05-12 3005 70005 2400.6 07-10-12 3001 70008 5760 07-08-12 3002 70010 1983.43 07-07-12 3004 70003 2480.4 07-10-12 3008 SELECT TO_CHAR(orderdate,'Q') AS QUARTER,SUM(p_amount) AS "Total Sales" FROM sales GROUP BY TO_CHAR(orderdate,'Q') ORDER BY QUARTER; ----------------------------------- QUARTER Total Sales 1 421.15 2 948.5 3 7743.43 4 5056.76

--SQL Query for Incremental Load --Source Table CREATE TABLE S1(sd1 number,sd2 varchar2(10),sdate date); --Target Table CREATE TABLE T1(td1 number,td2 varchar2(10),tdate date); INSERT INTO S1 VALUES(1,'antosh1','18-07-22'); INSERT INTO S1 VALUES(2,'antosh2','18-07-22'); INSERT INTO S1 VALUES(3,'antosh3','19-07-22'); INSERT INTO S1 VALUES(4,'antosh4','19-07-22'); INSERT INTO S1 VALUES(5,'antosh5','19-07-22'); COMMIT; SELECT * FROM S1; SELECT * FROM T1; --Full Load INSERT INTO T1(td1,td2,tdate) SELECT sd1,sd2,sdate FROM S1; COMMIT; SELECT * FROM T1; --INCREMENTAL LOAD INSERT INTO S1 VALUES(1,'antosh6','20-07-22'); INSERT INTO S1 VALUES(2,'antosh7','20-07-22'); INSERT INTO S1 VALUES(3,'antosh8','20-07-22'); INSERT INTO S1 VALUES(4,'antosh9','20-07-22'); INSERT INTO S1 VALUES(5,'antosh10','20-07-22'); SELECT * FROM S1; SELECT * FROM T1; --Incremental Load INSERT INTO T1(td1,td2,tdate) SELECT sd1,sd2,sdate FROM S1 WHERE sdate>(SELECT max(tdate) from T1); COMMIT; SELECT * FROM T1;