How do I setup a delta in ETL?

0 votes

asked Aug 21, 2021 by billy (13.3k points)

How can I pull data from the Data Lake with a changed record date in ETL?

Your comment on this question:

Upload image or document:

Preview:

Your name to display (optional):

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

Your answer

Upload image or document:

Preview:

Your name to display (optional):

Email me at this address if my answer is selected or commented on:Email me if my answer is selected or commented on

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

1 Answer

0 votes

answered Aug 21, 2021 by billy (13.3k points)

SELECT TOP 100 
  *
FROM
  "CIDMAS"
WHERE infor.CompassTimestamp() >=DATEADD(DAY,-7,GETDATE())

Your comment on this answer:

Upload image or document:

Preview:

Your name to display (optional):

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

M3 and Related Technology

A place for me to remember the answers to questions I had to dig around to find. Please feel free to add questions and answers for anything related to Infor, M3, ION, and it's sprawling family.

How do I setup a delta in ETL?

Your comment on this question:

Your answer

1 Answer

Your comment on this answer:

Most popular tags